Dynamic Memory Allocation for Multiple-Query Workloads
نویسندگان
چکیده
This paper studies the problem ol memory allocation and scheduling in a multiple query workload with widely varying resource requirements. Several memory allocation and scheduling schemes are presented and their performance is compared using a detailed simulation study. The results demonstrate the inadequacies of static schemes with fixed scheduling and memory allocation policies. A dynamic adaptive scheme which integrates schedtiling and memtiry allocation is developed and is shown to perform effectively under widely varying workloads.
منابع مشابه
An Incremental Memory Allocation Method for Mixed Workloads
This paper proposes and investigates an incremental memory allocation method for mixed database workloads of simple hash-join queries and short read transactions. Traditionally, a DBMS allocates all memory reserved for a query at the beginning of the query execution. However , there may be a prolonged period from the time the query begins to the time that all reserved memory is actually consume...
متن کاملQuery Performance Prediction for Analytical
of “ Query Performance Prediction for Analytical Workloads ” by Jennie Duggan, Ph.D., Brown University, May 2013 Modeling the complex interactions that arise when query workloads share computing resources and data is challenging albeit critical for a number of tasks such as Quality of Service (QoS) management in the emerging cloud-based database platforms, effective resource allocation for time...
متن کاملScheduling Multiple Data Visualization Query Workloads on a Shared Memory Machine
Query scheduling plays an important role when systems are faced with limited resources and high workloads. It becomes even more relevant for servers applying multiple query optimization techniques to batches of queries, in which portions of datasets as well as intermediate results are maintained in memory to speed up query evaluation. In this work, we present a dynamic query scheduling model ba...
متن کاملManaging Query Compilation Memory Consumption to Improve DBMS Throughput
While there are known performance trade-offs between database page buffer pool and query execution memory allocation policies, little has been written on the impact of query compilation memory use on overall throughput of the database management system (DBMS). We present a new aspect of the query optimization problem and discuss a solution implemented in Microsoft SQL Server 2005. The solution ...
متن کاملUsing Object-Awareness to Optimize Join Processing in the SAP HANA Aggregate Cache
The introduction of columnar in-memory databases, along with hardware evolution, has made the execution of transactional and analytical workloads on a single system both feasible and viable. Yet, doing analytics directly on the transactional data introduces an increasing amount of resourceintensive aggregate queries which can slow down the overall system performance in a multi-user environment....
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 1993